DELETE FROM wp_posts WHERE post_date < DATE_SUB(NOW(), INTERVAL 1 HOUR) AND post_status = 'publish'